Owner

dbo

Creation Date

10-07-2003 10:31:35

Remarks

Columns

Key	Id	Name	Type	Length	IsNullable	Collation
		EmployeeID	int	4
		LastName	nvarchar	40		SQL_Latin1_General_CP1_CI_AS
		LastName	sysname	40		SQL_Latin1_General_CP1_CI_AS
		FirstName	nvarchar	20		SQL_Latin1_General_CP1_CI_AS
		FirstName	sysname	20		SQL_Latin1_General_CP1_CI_AS
		Title	nvarchar	60		SQL_Latin1_General_CP1_CI_AS
		Title	sysname	60		SQL_Latin1_General_CP1_CI_AS
		TitleOfCourtesy	nvarchar	50		SQL_Latin1_General_CP1_CI_AS
		TitleOfCourtesy	sysname	50		SQL_Latin1_General_CP1_CI_AS
		BirthDate	datetime	8
		HireDate	datetime	8
		Address	nvarchar	120		SQL_Latin1_General_CP1_CI_AS
		Address	sysname	120		SQL_Latin1_General_CP1_CI_AS
		City	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		City	sysname	30		SQL_Latin1_General_CP1_CI_AS
		Region	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		Region	sysname	30		SQL_Latin1_General_CP1_CI_AS
		PostalCode	nvarchar	20		SQL_Latin1_General_CP1_CI_AS
		PostalCode	sysname	20		SQL_Latin1_General_CP1_CI_AS
		Country	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		Country	sysname	30		SQL_Latin1_General_CP1_CI_AS
		HomePhone	nvarchar	48		SQL_Latin1_General_CP1_CI_AS
		HomePhone	sysname	48		SQL_Latin1_General_CP1_CI_AS
		Extension	nvarchar	8		SQL_Latin1_General_CP1_CI_AS
		Extension	sysname	8		SQL_Latin1_General_CP1_CI_AS
		Photo	image	16
		Notes	ntext	16		SQL_Latin1_General_CP1_CI_AS
		ReportsTo	int	4
		PhotoPath	nvarchar	510		SQL_Latin1_General_CP1_CI_AS
		PhotoPath	sysname	510		SQL_Latin1_General_CP1_CI_AS

Indexes

Name	Description	Group	Keys
PK_Employees	clustered, unique, primary key	PRIMARY	EmployeeID
LastName	nonclustered	PRIMARY	LastName
PostalCode	nonclustered	PRIMARY	PostalCode

Relations

Employees EmployeeID

Orders   EmployeeID

Employees EmployeeID

EmployeeTerritories   EmployeeID

Employees EmployeeID

Employees   ReportsTo